Go to https://yamm.com/

Mail merge for Gmail - Yet Another Mail Merge - YAMM

Send mass emails with Gmail. Increase your chances of reaching the primary inbox. Track results in real-time directly from Google Sheets

Click on Installation -

Walk through instructions

Installation complete: How to launch YAMM?

Once YAMM is installed on your account, you can start using YAMM.

1. Once the installation is done, you can close the confirmation pop-up and click Done.
   

2. Create a new spreadsheet to start using YAMM.

3. To launch YAMM, select Extensions > Yet Another Mail Merge: Mail Merge for Gmail > Start Mail Merge.
   
   If your spreadsheet is empty, YAMM asks you to add recipients to your spreadsheet to start your mail merge.
   

Prepare a contacts list in a Google sheet

YAMM uses the email addresses listed in a Google sheet to send mail merges. All you need to do is name one of the columns Email and list any other contact information in additional columns.

About this task

To illustrate a basic contacts list, we demonstrate how to add and fill the columns Email, First name, and Last name in this order. For the purposes of each mail merge, only the Email column is required. You can use each additional column to send further personalized information to each recipient.

Prerequisites

Make sure that you are logged in to your Google account.

Procedure

1. Open Google Sheets.
2. Create a new Google sheet by selecting Blank under Start a new spreadsheet.
   
3. In the first row, define the column names Email, First name, and Last name.
   The only requirement is that you correctly type the name of the Email column. The order in which you define the column names does not matter.
   
4. Fill out data for the recipients of your first mail merge.
   

Create an email template in Gmail

For the purposes of sending your first mail merge, the example we provide is an announcement email that the fictitious Terrace Hotel is again open for reservations.

About this task

The example shows how to personalize the subject and the email body by using the markers {{First name}} and {{Last name}}. The markers are defined with double opening and closing curly braces in between which you define the marker name. The markers are replaced during the mail merge with the information from the First name and Last name column in the Google spreadsheet. As you can see, the name of the marker must match exactly the column name in the spreadsheet to ensure a successful replacement.

Prerequisites

Make sure that you are logged in to your Google account.

Procedure

Open Gmail.

1. Click Compose.
   
2. In the New Message window, compose the email template for your mail merge.
   1. Do not add any recipients in the To field.
   2. info
   3. Later when you start the mail merge, YAMM uses the email addresses from the Email column in the Google spreadsheet to automatically fill the To field as it sends an email to each recipient.
   4. Add a subject in the Subject field.
      In this example, you personalize the subject with a marker. By adding the {{First name}} marker, YAMM automatically replaces it during the mail merge with the first name of each recipient from the First name column in the Google spreadsheet.
   5. Draft the email by adding text and, optionally, images for extra appeal.
      You can again personalize the email body with markers. For example, in the opening greeting line, use the {{First name}} and {{Last name}} markers.
      
3. (Optional) Close the email draft by clicking the Close X button.

Result

The drafted email template is automatically saved in Gmail and is available in the Drafts folder.

What’s next

You can now use the drafted email template and the contacts list to send your first mail merge.

Send your first mail merge with YAMM

You start mail merges with YAMM from the Google spreadsheet containing the contacts information.

Prerequisites

• Make sure that you are logged in with the same Google account you used to create the spreadsheet in Google Sheets and the email template in Gmail
• Your Google spreadsheet contains the contacts information with the mandatory Email column.
• You have an email template saved in the Drafts folder of your Gmail account.

Procedure

1. In Google Sheets, open the spreadsheet with the contacts list.
2. Select Extensions > Yet Another Mail Merge: Mail Merge for Gmail > Start Mail Merge.
   
3. In the Start Mail Merge window, configure the mail merge.
   1. Note that YAMM correctly detects column A as the Email column.
      
   2. Type the name from which you send the mail merge in the Sender Name text box.
      
   3. Select the email template from the Email Template drop-down menu.
      
      
      
   4. info
   5. If the drafted email template does not appear in the list, click the Refresh button.
      
4. Click the Send emails button to send the mail merge to all recipients in the Google spreadsheet.
   
   
   
5. warning
6. Closing the spreadsheet pauses the sending process. You can then reopen the spreadsheet at any time, and YAMM seamlessly resumes sending the mail merge from where it left off.

Result

You have now sent your first mail merge! YAMM sends an email to your account congratulating you for your first mail merge.

What’s next

You can check the sent emails by opening the Sent folder in Gmail.

If you enabled tracking of the mail merge, opening any of the sent emails impacts the Opened number of emails in the Tracking Report. Because of this, only review the sent emails and do not open them to avoid misrepresentations in the data in the Tracking Report.